[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '145' >
64 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43867_1 | 061F-4449-BE | PO14471123403 | 100 | 286 | 215 | 145 | 1 | 2021-11-27 | 20.19 | 0.50 | 2021-11-15 | 1 | 12.03 | 1 | 20.19 | 1 | SO43867 | 2021-11-22 | 1.61 | 12.03 | 20.19 |
SO43867_2 | 061F-4449-BE | PO14471123403 | 100 | 286 | 347 | 145 | 1 | 2021-11-27 | 2039.99 | 51.00 | 2021-11-15 | 1 | 1912.15 | 1 | 2039.99 | 2 | SO43867 | 2021-11-22 | 163.20 | 1912.15 | 2039.99 |
SO43867_3 | 061F-4449-BE | PO14471123403 | 100 | 286 | 349 | 145 | 1 | 2021-11-27 | 4049.99 | 101.25 | 2021-11-15 | 2 | 1898.09 | 1 | 4049.99 | 3 | SO43867 | 2021-11-22 | 324.00 | 3796.19 | 2024.99 |
SO43867_4 | 061F-4449-BE | PO14471123403 | 100 | 286 | 232 | 145 | 1 | 2021-11-27 | 57.68 | 1.44 | 2021-11-15 | 2 | 31.72 | 1 | 57.68 | 4 | SO43867 | 2021-11-22 | 4.61 | 63.45 | 28.84 |
SO43867_5 | 061F-4449-BE | PO14471123403 | 100 | 286 | 346 | 145 | 1 | 2021-11-27 | 4079.99 | 102.00 | 2021-11-15 | 2 | 1912.15 | 1 | 4079.99 | 5 | SO43867 | 2021-11-22 | 326.40 | 3824.31 | 2039.99 |
SO43867_6 | 061F-4449-BE | PO14471123403 | 100 | 286 | 218 | 145 | 1 | 2021-11-27 | 11.40 | 0.29 | 2021-11-15 | 2 | 3.40 | 1 | 11.40 | 6 | SO43867 | 2021-11-22 | 0.91 | 6.79 | 5.70 |
SO43867_7 | 061F-4449-BE | PO14471123403 | 100 | 286 | 229 | 145 | 1 | 2021-11-27 | 86.52 | 2.16 | 2021-11-15 | 3 | 31.72 | 1 | 86.52 | 7 | SO43867 | 2021-11-22 | 6.92 | 95.17 | 28.84 |
SO43867_8 | 061F-4449-BE | PO14471123403 | 100 | 286 | 344 | 145 | 1 | 2021-11-27 | 8159.98 | 204.00 | 2021-11-15 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO43867 | 2021-11-22 | 652.80 | 7648.62 | 2039.99 |
SO43867_9 | 061F-4449-BE | PO14471123403 | 100 | 286 | 220 | 145 | 1 | 2021-11-27 | 40.37 | 1.01 | 2021-11-15 | 2 | 12.03 | 1 | 40.37 | 9 | SO43867 | 2021-11-22 | 3.23 | 24.06 | 20.19 |
SO43867_10 | 061F-4449-BE | PO14471123403 | 100 | 286 | 212 | 145 | 1 | 2021-11-27 | 20.19 | 0.50 | 2021-11-15 | 1 | 12.03 | 1 | 20.19 | 10 | SO43867 | 2021-11-22 | 1.61 | 12.03 | 20.19 |
SO43867_11 | 061F-4449-BE | PO14471123403 | 100 | 286 | 351 | 145 | 1 | 2021-11-27 | 4049.99 | 101.25 | 2021-11-15 | 2 | 1898.09 | 1 | 4049.99 | 11 | SO43867 | 2021-11-22 | 324.00 | 3796.19 | 2024.99 |
SO43867_12 | 061F-4449-BE | PO14471123403 | 100 | 286 | 223 | 145 | 1 | 2021-11-27 | 20.75 | 0.52 | 2021-11-15 | 4 | 5.71 | 1 | 20.75 | 12 | SO43867 | 2021-11-22 | 1.66 | 22.82 | 5.19 |
SO43867_13 | 061F-4449-BE | PO14471123403 | 100 | 286 | 296 | 145 | 1 | 2021-11-27 | 1429.41 | 35.74 | 2021-11-15 | 2 | 617.03 | 1 | 1429.41 | 13 | SO43867 | 2021-11-22 | 114.35 | 1234.06 | 714.70 |
SO43867_14 | 061F-4449-BE | PO14471123403 | 100 | 286 | 307 | 145 | 1 | 2021-11-27 | 722.59 | 18.06 | 2021-11-15 | 1 | 623.84 | 1 | 722.59 | 14 | SO43867 | 2021-11-22 | 57.81 | 623.84 | 722.59 |
SO43867_15 | 061F-4449-BE | PO14471123403 | 100 | 286 | 293 | 145 | 1 | 2021-11-27 | 2167.78 | 54.19 | 2021-11-15 | 3 | 623.84 | 1 | 2167.78 | 15 | SO43867 | 2021-11-22 | 173.42 | 1871.52 | 722.59 |
SO43867_16 | 061F-4449-BE | PO14471123403 | 100 | 286 | 292 | 145 | 1 | 2021-11-27 | 1637.40 | 40.94 | 2021-11-15 | 2 | 706.81 | 1 | 1637.40 | 16 | SO43867 | 2021-11-22 | 130.99 | 1413.62 | 818.70 |
SO43867_17 | 061F-4449-BE | PO14471123403 | 100 | 286 | 350 | 145 | 1 | 2021-11-27 | 4049.99 | 101.25 | 2021-11-15 | 2 | 1898.09 | 1 | 4049.99 | 17 | SO43867 | 2021-11-22 | 324.00 | 3796.19 | 2024.99 |
SO43867_18 | 061F-4449-BE | PO14471123403 | 100 | 286 | 235 | 145 | 1 | 2021-11-27 | 28.84 | 0.72 | 2021-11-15 | 1 | 31.72 | 1 | 28.84 | 18 | SO43867 | 2021-11-22 | 2.31 | 31.72 | 28.84 |
SO44513_1 | A881-41E7-AD | PO14471116260 | 100 | 286 | 229 | 145 | 1 | 2022-02-27 | 57.68 | 1.44 | 2022-02-15 | 2 | 31.72 | 1 | 57.68 | 1 | SO44513 | 2022-02-22 | 4.61 | 63.45 | 28.84 |
SO44513_2 | A881-41E7-AD | PO14471116260 | 100 | 286 | 292 | 145 | 1 | 2022-02-27 | 818.70 | 20.47 | 2022-02-15 | 1 | 706.81 | 1 | 818.70 | 2 | SO44513 | 2022-02-22 | 65.50 | 706.81 | 818.70 |
SO44513_3 | A881-41E7-AD | PO14471116260 | 100 | 286 | 215 | 145 | 1 | 2022-02-27 | 141.31 | 3.53 | 2022-02-15 | 7 | 12.03 | 1 | 141.31 | 3 | SO44513 | 2022-02-22 | 11.30 | 84.19 | 20.19 |
SO44513_4 | A881-41E7-AD | PO14471116260 | 100 | 286 | 300 | 145 | 1 | 2022-02-27 | 809.76 | 20.24 | 2022-02-15 | 1 | 699.09 | 1 | 809.76 | 4 | SO44513 | 2022-02-22 | 64.78 | 699.09 | 809.76 |
SO44513_5 | A881-41E7-AD | PO14471116260 | 100 | 286 | 349 | 145 | 1 | 2022-02-27 | 6074.98 | 151.87 | 2022-02-15 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO44513 | 2022-02-22 | 486.00 | 5694.28 | 2024.99 |
SO44513_6 | A881-41E7-AD | PO14471116260 | 100 | 286 | 218 | 145 | 1 | 2022-02-27 | 17.10 | 0.43 | 2022-02-15 | 3 | 3.40 | 1 | 17.10 | 6 | SO44513 | 2022-02-22 | 1.37 | 10.19 | 5.70 |
SO44513_7 | A881-41E7-AD | PO14471116260 | 100 | 286 | 212 | 145 | 1 | 2022-02-27 | 60.56 | 1.51 | 2022-02-15 | 3 | 12.03 | 1 | 60.56 | 7 | SO44513 | 2022-02-22 | 4.84 | 36.08 | 20.19 |
SO44513_8 | A881-41E7-AD | PO14471116260 | 100 | 286 | 307 | 145 | 1 | 2022-02-27 | 722.59 | 18.06 | 2022-02-15 | 1 | 623.84 | 1 | 722.59 | 8 | SO44513 | 2022-02-22 | 57.81 | 623.84 | 722.59 |
SO44513_9 | A881-41E7-AD | PO14471116260 | 100 | 286 | 350 | 145 | 1 | 2022-02-27 | 10124.97 | 253.12 | 2022-02-15 | 5 | 1898.09 | 1 | 10124.97 | 9 | SO44513 | 2022-02-22 | 810.00 | 9490.47 | 2024.99 |
SO44513_10 | A881-41E7-AD | PO14471116260 | 100 | 286 | 232 | 145 | 1 | 2022-02-27 | 57.68 | 1.44 | 2022-02-15 | 2 | 31.72 | 1 | 57.68 | 10 | SO44513 | 2022-02-22 | 4.61 | 63.45 | 28.84 |
SO44513_11 | A881-41E7-AD | PO14471116260 | 100 | 286 | 223 | 145 | 1 | 2022-02-27 | 10.37 | 0.26 | 2022-02-15 | 2 | 5.71 | 1 | 10.37 | 11 | SO44513 | 2022-02-22 | 0.83 | 11.41 | 5.19 |
SO44513_12 | A881-41E7-AD | PO14471116260 | 100 | 286 | 220 | 145 | 1 | 2022-02-27 | 40.37 | 1.01 | 2022-02-15 | 2 | 12.03 | 1 | 40.37 | 12 | SO44513 | 2022-02-22 | 3.23 | 24.06 | 20.19 |
SO44513_13 | A881-41E7-AD | PO14471116260 | 100 | 286 | 344 | 145 | 1 | 2022-02-27 | 14279.96 | 357.00 | 2022-02-15 | 7 | 1912.15 | 1 | 14279.96 | 13 | SO44513 | 2022-02-22 | 1142.40 | 13385.08 | 2039.99 |
SO44513_14 | A881-41E7-AD | PO14471116260 | 100 | 286 | 345 | 145 | 1 | 2022-02-27 | 4079.99 | 102.00 | 2022-02-15 | 2 | 1912.15 | 1 | 4079.99 | 14 | SO44513 | 2022-02-22 | 326.40 | 3824.31 | 2039.99 |
SO44513_15 | A881-41E7-AD | PO14471116260 | 100 | 286 | 296 | 145 | 1 | 2022-02-27 | 2144.11 | 53.60 | 2022-02-15 | 3 | 617.03 | 1 | 2144.11 | 15 | SO44513 | 2022-02-22 | 171.53 | 1851.08 | 714.70 |
SO44513_16 | A881-41E7-AD | PO14471116260 | 100 | 286 | 346 | 145 | 1 | 2022-02-27 | 4079.99 | 102.00 | 2022-02-15 | 2 | 1912.15 | 1 | 4079.99 | 16 | SO44513 | 2022-02-22 | 326.40 | 3824.31 | 2039.99 |
SO45296_1 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 220 | 145 | 1 | 2022-05-30 | 60.56 | 1.51 | 2022-05-18 | 3 | 12.03 | 1 | 60.56 | 1 | SO45296 | 2022-05-25 | 4.84 | 36.08 | 20.19 |
SO45296_2 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 229 | 145 | 1 | 2022-05-30 | 28.84 | 0.72 | 2022-05-18 | 1 | 31.72 | 1 | 28.84 | 2 | SO45296 | 2022-05-25 | 2.31 | 31.72 | 28.84 |
SO45296_3 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 344 | 145 | 1 | 2022-05-30 | 4079.99 | 102.00 | 2022-05-18 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO45296 | 2022-05-25 | 326.40 | 3824.31 | 2039.99 |
SO45296_4 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 350 | 145 | 1 | 2022-05-30 | 4049.99 | 101.25 | 2022-05-18 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO45296 | 2022-05-25 | 324.00 | 3796.19 | 2024.99 |
SO45296_5 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 307 | 145 | 1 | 2022-05-30 | 1445.19 | 36.13 | 2022-05-18 | 2 | 623.84 | 1 | 1445.19 | 5 | SO45296 | 2022-05-25 | 115.62 | 1247.68 | 722.59 |
SO45296_6 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 223 | 145 | 1 | 2022-05-30 | 25.93 | 0.65 | 2022-05-18 | 5 | 5.71 | 1 | 25.93 | 6 | SO45296 | 2022-05-25 | 2.07 | 28.53 | 5.19 |
SO45296_7 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 300 | 145 | 1 | 2022-05-30 | 809.76 | 20.24 | 2022-05-18 | 1 | 699.09 | 1 | 809.76 | 7 | SO45296 | 2022-05-25 | 64.78 | 699.09 | 809.76 |
SO45296_8 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 304 | 145 | 1 | 2022-05-30 | 714.70 | 17.87 | 2022-05-18 | 1 | 617.03 | 1 | 714.70 | 8 | SO45296 | 2022-05-25 | 57.18 | 617.03 | 714.70 |
SO45296_9 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 351 | 145 | 1 | 2022-05-30 | 6074.98 | 151.87 | 2022-05-18 | 3 | 1898.09 | 1 | 6074.98 | 9 | SO45296 | 2022-05-25 | 486.00 | 5694.28 | 2024.99 |
SO45296_10 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 296 | 145 | 1 | 2022-05-30 | 714.70 | 17.87 | 2022-05-18 | 1 | 617.03 | 1 | 714.70 | 10 | SO45296 | 2022-05-25 | 57.18 | 617.03 | 714.70 |
SO45296_11 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 232 | 145 | 1 | 2022-05-30 | 57.68 | 1.44 | 2022-05-18 | 2 | 31.72 | 1 | 57.68 | 11 | SO45296 | 2022-05-25 | 4.61 | 63.45 | 28.84 |
SO45296_12 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 212 | 145 | 1 | 2022-05-30 | 20.19 | 0.50 | 2022-05-18 | 1 | 12.03 | 1 | 20.19 | 12 | SO45296 | 2022-05-25 | 1.61 | 12.03 | 20.19 |
SO45296_13 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 346 | 145 | 1 | 2022-05-30 | 6119.98 | 153.00 | 2022-05-18 | 3 | 1912.15 | 1 | 6119.98 | 13 | SO45296 | 2022-05-25 | 489.60 | 5736.46 | 2039.99 |
SO45296_14 | 1FA6-4616-B7 | PO14471199142 | 100 | 286 | 215 | 145 | 1 | 2022-05-30 | 40.37 | 1.01 | 2022-05-18 | 2 | 12.03 | 1 | 40.37 | 14 | SO45296 | 2022-05-25 | 3.23 | 24.06 | 20.19 |
SO46053_1 | E530-47A7-9A | PO14471143194 | 100 | 286 | 344 | 145 | 1 | 2022-08-27 | 6119.98 | 153.00 | 2022-08-15 | 3 | 1912.15 | 1 | 6119.98 | 1 | SO46053 | 2022-08-22 | 489.60 | 5736.46 | 2039.99 |
SO46053_2 | E530-47A7-9A | PO14471143194 | 100 | 286 | 348 | 145 | 1 | 2022-08-27 | 12149.96 | 303.75 | 2022-08-15 | 6 | 1898.09 | 1 | 12149.96 | 2 | SO46053 | 2022-08-22 | 972.00 | 11388.57 | 2024.99 |
SO46053_3 | E530-47A7-9A | PO14471143194 | 100 | 286 | 350 | 145 | 1 | 2022-08-27 | 6074.98 | 151.87 | 2022-08-15 | 3 | 1898.09 | 1 | 6074.98 | 3 | SO46053 | 2022-08-22 | 486.00 | 5694.28 | 2024.99 |
SO46053_4 | E530-47A7-9A | PO14471143194 | 100 | 286 | 299 | 145 | 1 | 2022-08-27 | 809.76 | 20.24 | 2022-08-15 | 1 | 699.09 | 1 | 809.76 | 4 | SO46053 | 2022-08-22 | 64.78 | 699.09 | 809.76 |
SO46053_5 | E530-47A7-9A | PO14471143194 | 100 | 286 | 220 | 145 | 1 | 2022-08-27 | 80.75 | 2.02 | 2022-08-15 | 4 | 12.03 | 1 | 80.75 | 5 | SO46053 | 2022-08-22 | 6.46 | 48.11 | 20.19 |
SO46053_6 | E530-47A7-9A | PO14471143194 | 100 | 286 | 351 | 145 | 1 | 2022-08-27 | 6074.98 | 151.87 | 2022-08-15 | 3 | 1898.09 | 1 | 6074.98 | 6 | SO46053 | 2022-08-22 | 486.00 | 5694.28 | 2024.99 |
SO46053_7 | E530-47A7-9A | PO14471143194 | 100 | 286 | 235 | 145 | 1 | 2022-08-27 | 115.36 | 2.88 | 2022-08-15 | 4 | 31.72 | 1 | 115.36 | 7 | SO46053 | 2022-08-22 | 9.23 | 126.90 | 28.84 |
SO46053_8 | E530-47A7-9A | PO14471143194 | 100 | 286 | 349 | 145 | 1 | 2022-08-27 | 10124.97 | 253.12 | 2022-08-15 | 5 | 1898.09 | 1 | 10124.97 | 8 | SO46053 | 2022-08-22 | 810.00 | 9490.47 | 2024.99 |
SO46053_9 | E530-47A7-9A | PO14471143194 | 100 | 286 | 300 | 145 | 1 | 2022-08-27 | 809.76 | 20.24 | 2022-08-15 | 1 | 699.09 | 1 | 809.76 | 9 | SO46053 | 2022-08-22 | 64.78 | 699.09 | 809.76 |
SO46053_10 | E530-47A7-9A | PO14471143194 | 100 | 286 | 212 | 145 | 1 | 2022-08-27 | 40.37 | 1.01 | 2022-08-15 | 2 | 12.03 | 1 | 40.37 | 10 | SO46053 | 2022-08-22 | 3.23 | 24.06 | 20.19 |
SO46053_11 | E530-47A7-9A | PO14471143194 | 100 | 286 | 296 | 145 | 1 | 2022-08-27 | 714.70 | 17.87 | 2022-08-15 | 1 | 617.03 | 1 | 714.70 | 11 | SO46053 | 2022-08-22 | 57.18 | 617.03 | 714.70 |
SO46053_12 | E530-47A7-9A | PO14471143194 | 100 | 286 | 347 | 145 | 1 | 2022-08-27 | 4079.99 | 102.00 | 2022-08-15 | 2 | 1912.15 | 1 | 4079.99 | 12 | SO46053 | 2022-08-22 | 326.40 | 3824.31 | 2039.99 |
SO46053_13 | E530-47A7-9A | PO14471143194 | 100 | 286 | 293 | 145 | 1 | 2022-08-27 | 722.59 | 18.06 | 2022-08-15 | 1 | 623.84 | 1 | 722.59 | 13 | SO46053 | 2022-08-22 | 57.81 | 623.84 | 722.59 |
SO46053_14 | E530-47A7-9A | PO14471143194 | 100 | 286 | 232 | 145 | 1 | 2022-08-27 | 57.68 | 1.44 | 2022-08-15 | 2 | 31.72 | 1 | 57.68 | 14 | SO46053 | 2022-08-22 | 4.61 | 63.45 | 28.84 |
SO46053_15 | E530-47A7-9A | PO14471143194 | 100 | 286 | 345 | 145 | 1 | 2022-08-27 | 4079.99 | 102.00 | 2022-08-15 | 2 | 1912.15 | 1 | 4079.99 | 15 | SO46053 | 2022-08-22 | 326.40 | 3824.31 | 2039.99 |
SO46053_16 | E530-47A7-9A | PO14471143194 | 100 | 286 | 292 | 145 | 1 | 2022-08-27 | 818.70 | 20.47 | 2022-08-15 | 1 | 706.81 | 1 | 818.70 | 16 | SO46053 | 2022-08-22 | 65.50 | 706.81 | 818.70 |
Generated 2024-11-14 16:24:39.063 UTC